Google Cloudの組織ポリシー(制約)の一覧をExcelに出力してみた #cm_google_cloud_adcal_2024

google-cloud-orgpolicy
google-cloud-translate
pandas
openpyxl

pip install google-cloud-orgpolicy google-cloud-translate pandas openpyxl

gcloud auth application-default login

import pandas as pd
from google.cloud import orgpolicy_v2
from google.cloud import translate_v2 as translate

def translate_text(text, target_language="ja"):
    """
    Cloud Translation APIを使用してテキストを翻訳
    """
    client = translate.Client()
    result = client.translate(text, target_language=target_language)
    return result["translatedText"]

def list_constraints_to_excel(project_id, target_language="ja", output_file="constraints.xlsx"):
    """
    制約一覧をExcelファイルに出力
    """
    # Create a client for OrgPolicy
    client = orgpolicy_v2.OrgPolicyClient()
    request = orgpolicy_v2.ListConstraintsRequest(
        parent=project_id,
    )
    print(f"Listing constraints for: {project_id}")
    response = client.list_constraints(request=request)
    data = []
    for constraint in response:
        name = constraint.name
        display_name = constraint.display_name
        description = constraint.description
        constraint_default = constraint.constraint_default.name
        supports_dry_run = constraint.supports_dry_run
        # 翻訳
        translated_display_name = translate_text(display_name, target_language) if display_name else "No display name available"
        translated_description = translate_text(description, target_language) if description else "No description available"
        data.append({
            "Name": name,
            "Display Name": display_name,
            "Translated Display Name": translated_display_name,
            "Description": description,
            "Translated Description": translated_description,
            "Constraint Default": constraint_default,
            "Supports Dry Run": supports_dry_run,
        })

    df = pd.DataFrame(data)
    df.to_excel(output_file, index=False, engine="openpyxl")
    print(f"Constraints exported to {output_file}")

if __name__ == "__main__":
    project_id = "projects/プロジェクトID"  # プロジェクトIDを指定
    output_file = "constraints.xlsx"  # 出力ファイル名
    list_constraints_to_excel(project_id, output_file=output_file)

def translate_text(text, target_language="ja"):
    client = translate.Client()
    result = client.translate(text, target_language=target_language)
    return result["translatedText"]

def list_constraints_to_excel(project_id, target_language="ja", output_file="constraints.xlsx"):

response = client.list_constraints(request=request)
for constraint in response:
    name = constraint.name
    display_name = constraint.display_name
    description = constraint.description
    constraint_default = constraint.constraint_default.name
    supports_dry_run = constraint.supports_dry_run
    translated_display_name = translate_text(display_name, target_language) if display_name else "No display name available"
    translated_description = translate_text(description, target_language) if description else "No description available"

df = pd.DataFrame(data)
df.to_excel(output_file, index=False, engine="openpyxl")